Online SpreadSheet
< Back
Same Window - For Web Kiosk Mode
How To Use:
Column F is use to Calculate D & E
Enter a number value in Columns D & E. (On Same Row)
Add
To Add Columns D & E, type "+" or "Add" in Column F.
Subtract
To Subtract Columns D & E, type "-" or "Subtract" in Column F.
Divide
To Divide Columns D & E, type "/" or "Divide" in Column F.
Multiply
To Multiply Columns D & E, type "*" or "Multiply" in Column F.
Power
Column D to the power of Column E, type "^" or "Power" in Column F.
Average
To Average Columns D & E, type "Avg" or "Average" in Column F.
Percent
Column D % of Column E, type "%" or "Percent" in Column F.
Max
To get Max Number of Columns D & E, type "Max" in Column F.
Min
To get Min Number of Columns D & E, type "Min" in Column F.
Arc Tangent
Arc tangent of Column D/Column E, type "t" or "T" in Column F.
Note: You will see your Results once you click off of Column F.
Easy To Use
Calculations And Formals!
Add
Enter "5 + 6" in Columns A, B, C, D, or E.
Once you Click off the Column, you will see your answer.
Subtract
Enter "5 - 6" in Columns A, B, C, D, or E.
Once you Click off the Column, you will see your answer.
Divide
Enter "5 / 6" in Columns A, B, C, D, or E.
Once you Click off the Column, you will see your answer.
Multiply
Enter "5 * 6" in Columns A, B, C, D, or E.
Once you Click off the Column, you will see your answer.
Power
Enter "5 ^ 6" in Columns A, B, C, D, or E.
Once you Click off the Column, you will see your answer.
Average
Enter "5 avg 6" or "5 Avg 6" in Columns A, B, C, D, or E.
Once you Click off the Column, you will see your answer.
Percent
Enter "5 % 6" in Columns A, B, C, D, or E.
Once you Click off the Column, you will see your answer.
Arc Tangent
Enter "5 t 6" or "5 T 6" in Columns A, B, C, D, or E.
Once you Click off the Column, you will see your answer.
Year
Enter "year" or "Year" in Columns A, B, C, D, or E.
Once you Click off the Column, you will see this Year.
Month
Enter "month" or "Month" in Columns A, B, C, D, or E.
Once you Click off the Column, you will see this Month.
Date
Enter "date" or "Date" in Columns A, B, C, D, or E.
Once you Click off the Column, you will see today's Date.
Time
Enter "time" or "Time" in Columns A, B, C, D, or E.
Once you Click off the Column, you will see the current Time.
Methods
(x = a number)
"x abs"
: Returns absolute value of x.
"x acos"
: Returns arc cosine of x in radians.
"x asin"
: Returns arc sine of x in radians.
"x atan"
: Returns arc tan of x in radians.
"x ceil"
: Returns the smallest integer greater than or equal to x. (round up).
"x cos"
: Returns cosine of x, where x is in radians.
"x exp"
: Returns ex
"x floor"
: Returns the largest integer less than or equal to x. (round down)
"x log"
: Returns the natural logarithm (base E) of x.
"x random"
: Returns a pseudorandom number between 0 and 1. Example(s).
"x Round"
: Rounds x up or down to the nearest integer. It rounds .5 up. Example(s).
"x sin"
: Returns the Sin of x, where x is in radians.
"x sq"
: Returns x to the second power.
"x sqrt"
: Returns the square root of x.
"x tan"
: Returns the Tan of x, where x is in radians.
Mathematical Constants
E
: Euler's constant and the base of natural logarithms, approximately 2.718.
LN2
: Natural logarithm of 2, approximately 0.693.
LN10
: Natural logarithm of 10, approximately 2.302.
LOG2E
: Base 2 logarithm of E, approximately 1.442.
LOG10E
: Base 10 logarithm of E, approximately 0.434.
PI
: Ratio of the circumference of a circle to its diameter, approximately 3.14159.
SQRT1_2
: Square root of 1/2; equivalently, 1 over the square root of 2, approximately 0.707.
SQRT2
: Square root of 2, approximately 1.414.
Calculate Entire Column D, E or F
Add Column D
Enter "+" or "Add" in Cell D21
Once you Click off of Cell D21, Cell D21 will add entire Column D.
Average Column D
Enter "Avg" or "Average" in Cell D21
Once you Click off of Cell D21, Cell D21 will average entire Column D.
Add Column E
Enter "+" or "Add" in Cell E21
Once you Click off of Cell E21, Cell E21 will add entire Column E.
Average Column E
Enter "Avg" or "Average" in Cell D21
Once you Click off of Cell E21, Cell E21 will average entire Column E.
Add Column F
Enter "+" or "Add" in Cell F21
Once you Click off of Cell F21, Cell F21 will add entire Column F.
Average Column F
Enter "Avg" or "Average" in Cell D21
Once you Click off of Cell F21, Cell F21 will average entire Column F.